chado

-point number type decimal, single-precision float, double-precision doubles. Date type, datetime date and Time type, time type. int does not need to be set length. Modify the table structure of the command before ALTER TABLE. The self-increment property value can be filled out. MySQL has relational operators and logical operators. Anti-quotes can replace single quotes. Distinct filters duplicate data from the table name (one or more). Order By default Ascending. MySQL does not support double qu

On-line Chado is not a non-conforming void; therefore, some self-summary to solve this problemprinciples:FAQ: Pop-up layer is centered, the background is translucent but found a pull scroll bar immediately revealed that the background is only set the screen, the other parts are the original appearance, and the pop-up layer because the scroll bar movement is missing this is the majority of online pop-up layer of the common problem solving method, There

pg_basebackup-F P--progress-d/home/postgres/data-h192.168.1.202-P5432-U Replica--Password used the pg_basebackup command here,/home/postgres/after the data directory is empty, you can see that the existing files in this directory are the same. 2.2Go to the/home/postgres/data directory and modify the recovery.conf, just change a few places. Standby_mode= On#This indicates that the machine is from the libraryPrimary_conninfo ='host=192.168.1.202 port=5432 User=replica password=replica' #This ind

been promoted successfully:/usr/pgsql-10/bin/pg_controldata-d/var/lib/pgsql/10/data/| grep clusterDatabase cluster State:in Production--Description: If the value is "in production" the description is the main library, if the value is "in Archive recovery" The description is a standby library.Create a test table on 10.0.20.26 to verify that the new replication is healthy at a later timeCREATE TABLE TEST_T1 (a int); INSERT INTO TEST_T1 select 100;select * from Test_t1;10.0.20.25 use Pg_rewind to

pointRollback: rollback--restore--Query1. Query all select * FROM table names2. Check the specified column select column name 1, column name 2 from table name--Chado column separated by commas3. Replace column name Select column name ' Replace name ' from table name--replace multiple column names separated by commas4. Check the specified line select * from table name where column name = ' Data '--* denotes all5. Check the specified row by condition c